Panas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	111923
Missing cells	11724
Missing cells (%)	0.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	18.8 MiB
Average record size in memory	176.0 B

Variable types

Categorical	11
DateTime	6
Numeric	5

Alerts

`order_id` has a high cardinality: 98115 distinct values	High cardinality
`customer_id` has a high cardinality: 98115 distinct values	High cardinality
`product_id` has a high cardinality: 32486 distinct values	High cardinality
`seller_id` has a high cardinality: 3050 distinct values	High cardinality
`product_category_name` has a high cardinality: 73 distinct values	High cardinality
`customer_unique_id` has a high cardinality: 94855 distinct values	High cardinality
`customer_city` has a high cardinality: 4111 distinct values	High cardinality
`mes_compra` is highly correlated with `ano_compra`	High correlation
`ano_compra` is highly correlated with `mes_compra`	High correlation
`mes_compra` is highly correlated with `ano_compra`	High correlation
`ano_compra` is highly correlated with `mes_compra`	High correlation
`ano_compra` is highly correlated with `ano_mes`	High correlation
`ano_mes` is highly correlated with `ano_compra`	High correlation
`mes_compra` is highly correlated with `ano_compra` and 1 other fields	High correlation
`ano_compra` is highly correlated with `mes_compra` and 1 other fields	High correlation
`ano_mes` is highly correlated with `mes_compra` and 1 other fields	High correlation
`order_delivered_carrier_date` has 1873 (1.7%) missing values	Missing
`order_delivered_customer_date` has 3119 (2.8%) missing values	Missing
`product_category_name` has 2315 (2.1%) missing values	Missing
`order_id` is uniformly distributed	Uniform
`customer_id` is uniformly distributed	Uniform
`customer_unique_id` is uniformly distributed	Uniform

Reproduction

Analysis started	2022-09-01 17:39:51.921877
Analysis finished	2022-09-01 17:40:33.028876
Duration	41.11 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

order_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98115
Distinct (%)	87.7%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

8272b63d03f5f79c56e9e4120aec44ef	21
ab14fdcfbe524636d65ee38360e22ce8	20
1b15974a0141d54e36626dca3fdc731a	20
428a2f660dc84138d969ccd69a0ab6d5	15
9ef13efd6949e4573a18964dd1bbe7f5	15
Other values (98110)	111832

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3581536
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88438 ?
Unique (%)	79.0%

Sample

1st row	e481f51cbdc54678b7cc49136f2d6af7
2nd row	53cdb2fc8bc7dce0b6741e2150273451
3rd row	47770eb9100c2d0c44946d9cf07ec65d
4th row	949d5b44dbf5de918fe9c16f97b45f8a
5th row	ad21c59c0840e6cb83a9ceb5573f8159

Common Values

Value	Count	Frequency (%)
8272b63d03f5f79c56e9e4120aec44ef	21	< 0.1%
ab14fdcfbe524636d65ee38360e22ce8	20	< 0.1%
1b15974a0141d54e36626dca3fdc731a	20	< 0.1%
428a2f660dc84138d969ccd69a0ab6d5	15	< 0.1%
9ef13efd6949e4573a18964dd1bbe7f5	15	< 0.1%
9bdc4d4c71aa1de4606060929dee888c	14	< 0.1%
73c8ab38f07dc94389065f7eba4f297a	14	< 0.1%
37ee401157a3a0b28c9c6d0ed8c3b24b	13	< 0.1%
c05d6a79e55da72ca780ce90364abed9	12	< 0.1%
af822dacd6f5cff7376413c03a388bb7	12	< 0.1%
Other values (98105)	111767	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
8272b63d03f5f79c56e9e4120aec44ef	21	< 0.1%
1b15974a0141d54e36626dca3fdc731a	20	< 0.1%
ab14fdcfbe524636d65ee38360e22ce8	20	< 0.1%
428a2f660dc84138d969ccd69a0ab6d5	15	< 0.1%
9ef13efd6949e4573a18964dd1bbe7f5	15	< 0.1%
9bdc4d4c71aa1de4606060929dee888c	14	< 0.1%
73c8ab38f07dc94389065f7eba4f297a	14	< 0.1%
37ee401157a3a0b28c9c6d0ed8c3b24b	13	< 0.1%
2c2a19b5703863c908512d135aa6accc	12	< 0.1%
637617b3ffe9e2f7a2411243829226d0	12	< 0.1%
Other values (98105)	111767	99.9%

Most occurring characters

Value	Count	Frequency (%)
4	225109	6.3%
e	224538	6.3%
6	224490	6.3%
3	224365	6.3%
b	224345	6.3%
7	224298	6.3%
a	224031	6.3%
2	223936	6.3%
1	223771	6.2%
8	223741	6.2%
Other values (6)	1338912	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2238464	62.5%
Lowercase Letter	1343072	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	225109	10.1%
6	224490	10.0%
3	224365	10.0%
7	224298	10.0%
2	223936	10.0%
1	223771	10.0%
8	223741	10.0%
9	223318	10.0%
0	223076	10.0%
5	222360	9.9%

Lowercase Letter

Value	Count	Frequency (%)
e	224538	16.7%
b	224345	16.7%
a	224031	16.7%
c	223680	16.7%
f	223608	16.6%
d	222870	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2238464	62.5%
Latin	1343072	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	225109	10.1%
6	224490	10.0%
3	224365	10.0%
7	224298	10.0%
2	223936	10.0%
1	223771	10.0%
8	223741	10.0%
9	223318	10.0%
0	223076	10.0%
5	222360	9.9%

Latin

Value	Count	Frequency (%)
e	224538	16.7%
b	224345	16.7%
a	224031	16.7%
c	223680	16.7%
f	223608	16.6%
d	222870	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3581536	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	225109	6.3%
e	224538	6.3%
6	224490	6.3%
3	224365	6.3%
b	224345	6.3%
7	224298	6.3%
a	224031	6.3%
2	223936	6.3%
1	223771	6.2%
8	223741	6.2%
Other values (6)	1338912	37.4%

customer_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	98115
Distinct (%)	87.7%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

fc3d1daec319d62d49bfb5e1f83123e9	21
bd5d39761aa56689a265d95d8d32b8be	20
be1b70680b9f9694d8c70f41fa3dc92b	20
10de381f8a8d23fff822753305f71cae	15
adb32467ecc74b53576d9d13a5a55891	15
Other values (98110)	111832

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3581536
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	88438 ?
Unique (%)	79.0%

Sample

1st row	9ef432eb6251297304e76186b10a928d
2nd row	b0830fb4747a6c6d20dea0b8c802d7ef
3rd row	41ce2a54c0b03bf3443c3d931a367089
4th row	f88197465ea7920adcdbec7375364d82
5th row	8ab97904e6daea8866dbdbc4fb7aad2c

Common Values

Value	Count	Frequency (%)
fc3d1daec319d62d49bfb5e1f83123e9	21	< 0.1%
bd5d39761aa56689a265d95d8d32b8be	20	< 0.1%
be1b70680b9f9694d8c70f41fa3dc92b	20	< 0.1%
10de381f8a8d23fff822753305f71cae	15	< 0.1%
adb32467ecc74b53576d9d13a5a55891	15	< 0.1%
a7693fba2ff9583c78751f2b66ecab9d	14	< 0.1%
d5f2b3f597c7ccafbb5cac0bcc3d6024	14	< 0.1%
7d321bd4e8ba1caf74c4c1aabd9ae524	13	< 0.1%
3b54b5978e9ace64a63f90d176ffb158	12	< 0.1%
9eb3d566e87289dcb0acf28e1407c839	12	< 0.1%
Other values (98105)	111767	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fc3d1daec319d62d49bfb5e1f83123e9	21	< 0.1%
be1b70680b9f9694d8c70f41fa3dc92b	20	< 0.1%
bd5d39761aa56689a265d95d8d32b8be	20	< 0.1%
10de381f8a8d23fff822753305f71cae	15	< 0.1%
adb32467ecc74b53576d9d13a5a55891	15	< 0.1%
a7693fba2ff9583c78751f2b66ecab9d	14	< 0.1%
d5f2b3f597c7ccafbb5cac0bcc3d6024	14	< 0.1%
7d321bd4e8ba1caf74c4c1aabd9ae524	13	< 0.1%
0d93f21f3e8543a9d0d8ece01561f5b2	12	< 0.1%
daf15f1b940cc6a72ba558f093dc00dd	12	< 0.1%
Other values (98105)	111767	99.9%

Most occurring characters

Value	Count	Frequency (%)
f	224619	6.3%
5	224352	6.3%
c	224326	6.3%
1	224233	6.3%
8	224174	6.3%
6	224111	6.3%
2	223960	6.3%
7	223843	6.2%
a	223829	6.2%
3	223825	6.2%
Other values (6)	1340264	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2238036	62.5%
Lowercase Letter	1343500	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	224352	10.0%
1	224233	10.0%
8	224174	10.0%
6	224111	10.0%
2	223960	10.0%
7	223843	10.0%
3	223825	10.0%
9	223530	10.0%
4	223011	10.0%
0	222997	10.0%

Lowercase Letter

Value	Count	Frequency (%)
f	224619	16.7%
c	224326	16.7%
a	223829	16.7%
b	223678	16.6%
e	223530	16.6%
d	223518	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2238036	62.5%
Latin	1343500	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	224352	10.0%
1	224233	10.0%
8	224174	10.0%
6	224111	10.0%
2	223960	10.0%
7	223843	10.0%
3	223825	10.0%
9	223530	10.0%
4	223011	10.0%
0	222997	10.0%

Latin

Value	Count	Frequency (%)
f	224619	16.7%
c	224326	16.7%
a	223829	16.7%
b	223678	16.6%
e	223530	16.6%
d	223518	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3581536	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
f	224619	6.3%
5	224352	6.3%
c	224326	6.3%
1	224233	6.3%
8	224174	6.3%
6	224111	6.3%
2	223960	6.3%
7	223843	6.2%
a	223829	6.2%
3	223825	6.2%
Other values (6)	1340264	37.4%

order_status
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

delivered	108811
shipped	1171
canceled	637
unavailable	601
processing	355
Other values (3)	348

Length

Max length	11
Median length	9
Mean length	8.984140883
Min length	7

Characters and Unicode

Total characters	1005532
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	108811	97.2%
shipped	1171	1.0%
canceled	637	0.6%
unavailable	601	0.5%
processing	355	0.3%
invoiced	340	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
delivered	108811	97.2%
shipped	1171	1.0%
canceled	637	0.6%
unavailable	601	0.5%
processing	355	0.3%
invoiced	340	0.3%
created	5	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	330187	32.8%
d	219778	21.9%
i	111618	11.1%
l	110650	11.0%
v	109755	10.9%
r	109174	10.9%
p	2703	0.3%
a	2448	0.2%
c	1974	0.2%
n	1933	0.2%
Other values (7)	5312	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1005532	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	330187	32.8%
d	219778	21.9%
i	111618	11.1%
l	110650	11.0%
v	109755	10.9%
r	109174	10.9%
p	2703	0.3%
a	2448	0.2%
c	1974	0.2%
n	1933	0.2%
Other values (7)	5312	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1005532	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	330187	32.8%
d	219778	21.9%
i	111618	11.1%
l	110650	11.0%
v	109755	10.9%
r	109174	10.9%
p	2703	0.3%
a	2448	0.2%
c	1974	0.2%
n	1933	0.2%
Other values (7)	5312	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1005532	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	330187	32.8%
d	219778	21.9%
i	111618	11.1%
l	110650	11.0%
v	109755	10.9%
r	109174	10.9%
p	2703	0.3%
a	2448	0.2%
c	1974	0.2%
n	1933	0.2%
Other values (7)	5312	0.5%

order_purchase_timestamp
Date

Distinct	592
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

Minimum	2017-01-06 00:00:00
Maximum	2018-08-20 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_approved_at
Date

Distinct	591
Distinct (%)	0.5%
Missing	115
Missing (%)	0.1%
Memory size	874.5 KiB

Minimum	2017-01-06 00:00:00
Maximum	2018-08-24 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_delivered_carrier_date
Date

MISSING

Distinct	509
Distinct (%)	0.5%
Missing	1873
Missing (%)	1.7%
Memory size	874.5 KiB

Minimum	2017-01-09 00:00:00
Maximum	2018-09-11 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_delivered_customer_date
Date

MISSING

Distinct	603
Distinct (%)	0.6%
Missing	3119
Missing (%)	2.8%
Memory size	874.5 KiB

Minimum	2017-01-12 00:00:00
Maximum	2018-10-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_estimated_delivery_date
Date

Distinct	418
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

Minimum	2017-02-07 00:00:00
Maximum	2018-10-25 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

order_item_id
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	< 0.1%
Missing	717
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.198019891

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	874.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7064445674
Coefficient of variation (CV)	0.5896768265
Kurtosis	104.2594651
Mean	1.198019891
Median Absolute Deviation (MAD)	0
Skewness	7.601320234
Sum	133227
Variance	0.4990639268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	97398	87.0%
2	9677	8.6%
3	2261	2.0%
4	952	0.9%
5	453	0.4%
6	252	0.2%
7	58	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	66	0.1%
(Missing)	717	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	97398	87.0%
2	9677	8.6%
3	2261	2.0%
4	952	0.9%
5	453	0.4%
6	252	0.2%
7	58	0.1%
8	36	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	3	< 0.1%
19	3	< 0.1%
18	3	< 0.1%
17	3	< 0.1%
16	3	< 0.1%
15	5	< 0.1%
14	7	< 0.1%
13	8	< 0.1%
12	13	< 0.1%

product_id
Categorical

HIGH CARDINALITY

Distinct	32486
Distinct (%)	29.2%
Missing	717
Missing (%)	0.6%
Memory size	874.5 KiB

aca2eb7d00ea1a7b8ebd4e68314663af	527
99a4788cb24856965c36a24e339b6058	488
422879e10f46682990de24d770e7f83d	484
389d119b48cf3043d311335e499d9c6b	392
368c6c730842d78016ad823897a372db	387
Other values (32481)	108928

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3558592
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17864 ?
Unique (%)	16.1%

Sample

1st row	87285b34884572647811a353c7ac498a
2nd row	595fac2a385ac33a80bd5114aec74eb8
3rd row	aa4383b373c6aca5d8797843e5594415
4th row	d0b61bfb1de832b15ba9d266ca96e5b0
5th row	65266b2da20d04dbe00c5c2d3bb7859e

Common Values

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	527	0.5%
99a4788cb24856965c36a24e339b6058	488	0.4%
422879e10f46682990de24d770e7f83d	484	0.4%
389d119b48cf3043d311335e499d9c6b	392	0.4%
368c6c730842d78016ad823897a372db	387	0.3%
53759a2ecddad2bb87a079a1f1519f73	370	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	342	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	281	0.3%
3dd2a17168ec895c781a9191c1e95ad7	274	0.2%
Other values (32476)	107338	95.9%
(Missing)	717	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	527	0.5%
99a4788cb24856965c36a24e339b6058	488	0.4%
422879e10f46682990de24d770e7f83d	484	0.4%
389d119b48cf3043d311335e499d9c6b	392	0.4%
368c6c730842d78016ad823897a372db	387	0.3%
53759a2ecddad2bb87a079a1f1519f73	370	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	342	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	281	0.3%
3dd2a17168ec895c781a9191c1e95ad7	274	0.2%
Other values (32476)	107338	96.5%

Most occurring characters

Value	Count	Frequency (%)
3	228870	6.4%
9	226536	6.4%
e	224669	6.3%
7	224186	6.3%
8	223825	6.3%
4	223416	6.3%
a	222982	6.3%
c	222118	6.2%
0	222106	6.2%
2	222081	6.2%
Other values (6)	1317803	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2233846	62.8%
Lowercase Letter	1324746	37.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	228870	10.2%
9	226536	10.1%
7	224186	10.0%
8	223825	10.0%
4	223416	10.0%
0	222106	9.9%
2	222081	9.9%
5	221504	9.9%
6	221108	9.9%
1	220214	9.9%

Lowercase Letter

Value	Count	Frequency (%)
e	224669	17.0%
a	222982	16.8%
c	222118	16.8%
b	220702	16.7%
d	218679	16.5%
f	215596	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2233846	62.8%
Latin	1324746	37.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	228870	10.2%
9	226536	10.1%
7	224186	10.0%
8	223825	10.0%
4	223416	10.0%
0	222106	9.9%
2	222081	9.9%
5	221504	9.9%
6	221108	9.9%
1	220214	9.9%

Latin

Value	Count	Frequency (%)
e	224669	17.0%
a	222982	16.8%
c	222118	16.8%
b	220702	16.7%
d	218679	16.5%
f	215596	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3558592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	228870	6.4%
9	226536	6.4%
e	224669	6.3%
7	224186	6.3%
8	223825	6.3%
4	223416	6.3%
a	222982	6.3%
c	222118	6.2%
0	222106	6.2%
2	222081	6.2%
Other values (6)	1317803	37.0%

seller_id
Categorical

HIGH CARDINALITY

Distinct	3050
Distinct (%)	2.7%
Missing	717
Missing (%)	0.6%
Memory size	874.5 KiB

6560211a19b47992c3666cc44a7e94c0	2000
4a3ca9315b744ce9f8e9374361493884	1982
1f50f920176fa81dab994f9023523100	1923
cc419e0650a3c5ba77189a1882b7556a	1766
da8622b14eb17ae2831f4ac5b9dab84a	1534
Other values (3045)	102001

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3558592
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	497 ?
Unique (%)	0.4%

Sample

1st row	3504c0cb71d7fa48d967e0e4c94d59d9
2nd row	289cdb325fb7e7f891c38608bf9e0962
3rd row	4869f7a5dfa277a7dca6462dcf3b52b2
4th row	66922902710d126a0e7d26b0e3805106
5th row	2c9e548be18521d1c43cde1c582c6de8

Common Values

Value	Count	Frequency (%)
6560211a19b47992c3666cc44a7e94c0	2000	1.8%
4a3ca9315b744ce9f8e9374361493884	1982	1.8%
1f50f920176fa81dab994f9023523100	1923	1.7%
cc419e0650a3c5ba77189a1882b7556a	1766	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1534	1.4%
955fee9216a65b617aa5c0531780ce60	1483	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1422	1.3%
7c67e1448b00f6e969d365cea6b010ab	1364	1.2%
ea8482cd71df3c1969d7b9473ff13abc	1200	1.1%
7a67c85e85bb2ce8582c35f2203ad736	1170	1.0%
Other values (3040)	95362	85.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
6560211a19b47992c3666cc44a7e94c0	2000	1.8%
4a3ca9315b744ce9f8e9374361493884	1982	1.8%
1f50f920176fa81dab994f9023523100	1923	1.7%
cc419e0650a3c5ba77189a1882b7556a	1766	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1534	1.4%
955fee9216a65b617aa5c0531780ce60	1483	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1422	1.3%
7c67e1448b00f6e969d365cea6b010ab	1364	1.2%
ea8482cd71df3c1969d7b9473ff13abc	1200	1.1%
7a67c85e85bb2ce8582c35f2203ad736	1170	1.1%
Other values (3040)	95362	85.8%

Most occurring characters

Value	Count	Frequency (%)
1	241277	6.8%
c	234639	6.6%
4	233185	6.6%
6	229166	6.4%
0	228229	6.4%
a	226825	6.4%
3	226197	6.4%
b	226194	6.4%
9	220774	6.2%
2	220068	6.2%
Other values (6)	1272038	35.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2250830	63.3%
Lowercase Letter	1307762	36.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	241277	10.7%
4	233185	10.4%
6	229166	10.2%
0	228229	10.1%
3	226197	10.0%
9	220774	9.8%
2	220068	9.8%
5	217495	9.7%
8	217424	9.7%
7	217015	9.6%

Lowercase Letter

Value	Count	Frequency (%)
c	234639	17.9%
a	226825	17.3%
b	226194	17.3%
e	209539	16.0%
f	206299	15.8%
d	204266	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2250830	63.3%
Latin	1307762	36.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	241277	10.7%
4	233185	10.4%
6	229166	10.2%
0	228229	10.1%
3	226197	10.0%
9	220774	9.8%
2	220068	9.8%
5	217495	9.7%
8	217424	9.7%
7	217015	9.6%

Latin

Value	Count	Frequency (%)
c	234639	17.9%
a	226825	17.3%
b	226194	17.3%
e	209539	16.0%
f	206299	15.8%
d	204266	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3558592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	241277	6.8%
c	234639	6.6%
4	233185	6.6%
6	229166	6.4%
0	228229	6.4%
a	226825	6.4%
3	226197	6.4%
b	226194	6.4%
9	220774	6.2%
2	220068	6.2%
Other values (6)	1272038	35.7%

shipping_limit_date
Date

Distinct	528
Distinct (%)	0.5%
Missing	717
Missing (%)	0.6%
Memory size	874.5 KiB

Minimum	2017-01-10 00:00:00
Maximum	2020-04-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ_≥0)

Distinct	5914
Distinct (%)	5.3%
Missing	717
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	120.8459546

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	874.5 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17.37
Q1	39.9
median	74.99
Q3	134.99
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95.09

Descriptive statistics

Standard deviation	183.9417558
Coefficient of variation (CV)	1.522117611
Kurtosis	121.1401143
Mean	120.8459546
Median Absolute Deviation (MAD)	42.09
Skewness	7.933903095
Sum	13438795.23
Variance	33834.56953
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2446	2.2%
69.9	1975	1.8%
49.9	1919	1.7%
89.9	1536	1.4%
99.9	1418	1.3%
39.9	1318	1.2%
29.9	1301	1.2%
79.9	1196	1.1%
19.9	1181	1.1%
29.99	1162	1.0%
Other values (5904)	95754	85.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.29	1	< 0.1%
2.99	1	< 0.1%
3	2	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%
3.54	1	< 0.1%
3.85	3	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6729	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%

freight_value
Real number (ℝ_≥0)

Distinct	6977
Distinct (%)	6.3%
Missing	717
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	20.03207893

Minimum	0
Maximum	409.68
Zeros	381
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	874.5 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.28
Q3	21.18
95-th percentile	45.2
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.1

Descriptive statistics

Standard deviation	15.8479909
Coefficient of variation (CV)	0.7911306139
Kurtosis	59.74854478
Mean	20.03207893
Median Absolute Deviation (MAD)	3.59
Skewness	5.64120452
Sum	2227687.37
Variance	251.1588157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3707	3.3%
7.78	2260	2.0%
14.1	1875	1.7%
11.85	1845	1.6%
18.23	1561	1.4%
7.39	1476	1.3%
16.11	1151	1.0%
15.23	1005	0.9%
8.72	885	0.8%
16.79	872	0.8%
Other values (6967)	94569	84.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	381	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	4	< 0.1%
0.06	11	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

product_category_name
Categorical

HIGH CARDINALITY
MISSING

Distinct	73
Distinct (%)	0.1%
Missing	2315
Missing (%)	2.1%
Memory size	874.5 KiB

cama_mesa_banho	11016
beleza_saude	9487
esporte_lazer	8541
moveis_decoracao	8223
informatica_acessorios	7752
Other values (68)	64589

Length

Max length	46
Median length	32
Mean length	14.8608587
Min length	3

Characters and Unicode

Total characters	1628869
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	utilidades_domesticas
2nd row	perfumaria
3rd row	automotivo
4th row	pet_shop
5th row	papelaria

Common Values

Value	Count	Frequency (%)
cama_mesa_banho	11016	9.8%
beleza_saude	9487	8.5%
esporte_lazer	8541	7.6%
moveis_decoracao	8223	7.3%
informatica_acessorios	7752	6.9%
utilidades_domesticas	6840	6.1%
relogios_presentes	5932	5.3%
telefonia	4501	4.0%
ferramentas_jardim	4325	3.9%
automotivo	4174	3.7%
Other values (63)	38817	34.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cama_mesa_banho	11016	10.1%
beleza_saude	9487	8.7%
esporte_lazer	8541	7.8%
moveis_decoracao	8223	7.5%
informatica_acessorios	7752	7.1%
utilidades_domesticas	6840	6.2%
relogios_presentes	5932	5.4%
telefonia	4501	4.1%
ferramentas_jardim	4325	3.9%
automotivo	4174	3.8%
Other values (63)	38817	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	198340	12.2%
a	195308	12.0%
s	162363	10.0%
o	161280	9.9%
i	108297	6.6%
r	105230	6.5%
_	103261	6.3%
t	78568	4.8%
c	77136	4.7%
m	73290	4.5%
Other values (18)	365796	22.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1525341	93.6%
Connector Punctuation	103261	6.3%
Decimal Number	267	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	198340	13.0%
a	195308	12.8%
s	162363	10.6%
o	161280	10.6%
i	108297	7.1%
r	105230	6.9%
t	78568	5.2%
c	77136	5.1%
m	73290	4.8%
n	55685	3.7%
Other values (16)	309844	20.3%

Connector Punctuation

Value	Count	Frequency (%)
_	103261	100.0%

Decimal Number

Value	Count	Frequency (%)
2	267	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1525341	93.6%
Common	103528	6.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	198340	13.0%
a	195308	12.8%
s	162363	10.6%
o	161280	10.6%
i	108297	7.1%
r	105230	6.9%
t	78568	5.2%
c	77136	5.1%
m	73290	4.8%
n	55685	3.7%
Other values (16)	309844	20.3%

Common

Value	Count	Frequency (%)
_	103261	99.7%
2	267	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1628869	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	198340	12.2%
a	195308	12.0%
s	162363	10.0%
o	161280	9.9%
i	108297	6.6%
r	105230	6.5%
_	103261	6.3%
t	78568	4.8%
c	77136	4.7%
m	73290	4.5%
Other values (18)	365796	22.5%

customer_unique_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	94855
Distinct (%)	84.8%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

c8460e4251689ba205045f3ea17884a1	24
4546caea018ad8c692964e3382debd19	21
c402f431464c72e27330a67f7b94d4fb	20
698e1cf81d01a3d389d96145f7fa6df8	20
0f5ac8d5c31de21d2f25e24be15bbffb	18
Other values (94850)	111820

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3581536
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83088 ?
Unique (%)	74.2%

Sample

1st row	7c396fd4830fd04220f754e42b4e5bff
2nd row	af07308b275d755c9edb36a90c618231
3rd row	3a653a41f6f9fc3d2a113cf8398680e8
4th row	7c142cf63193a1473d2e66489a9ae977
5th row	72632f0f9dd73dfee390c9b22eb56dd6

Common Values

Value	Count	Frequency (%)
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
4546caea018ad8c692964e3382debd19	21	< 0.1%
c402f431464c72e27330a67f7b94d4fb	20	< 0.1%
698e1cf81d01a3d389d96145f7fa6df8	20	< 0.1%
0f5ac8d5c31de21d2f25e24be15bbffb	18	< 0.1%
8d50f5eadf50201ccdcedfb9e2ac8455	17	< 0.1%
11f97da02237a49c8e783dfda6f50e8e	15	< 0.1%
eae0a83d752b1dd32697e0e7b4221656	15	< 0.1%
3e43e6105506432c953e165fb2acf44c	14	< 0.1%
f7ea4eef770a388bd5b225acfc546604	14	< 0.1%
Other values (94845)	111745	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
4546caea018ad8c692964e3382debd19	21	< 0.1%
c402f431464c72e27330a67f7b94d4fb	20	< 0.1%
698e1cf81d01a3d389d96145f7fa6df8	20	< 0.1%
0f5ac8d5c31de21d2f25e24be15bbffb	18	< 0.1%
8d50f5eadf50201ccdcedfb9e2ac8455	17	< 0.1%
11f97da02237a49c8e783dfda6f50e8e	15	< 0.1%
eae0a83d752b1dd32697e0e7b4221656	15	< 0.1%
31e412b9fb766b6794724ed17a41dfa6	14	< 0.1%
3e43e6105506432c953e165fb2acf44c	14	< 0.1%
Other values (94845)	111745	99.8%

Most occurring characters

Value	Count	Frequency (%)
6	224540	6.3%
1	224529	6.3%
e	224189	6.3%
8	224183	6.3%
a	224044	6.3%
9	224023	6.3%
d	223980	6.3%
5	223931	6.3%
3	223876	6.3%
0	223850	6.3%
Other values (6)	1340391	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2239049	62.5%
Lowercase Letter	1342487	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	224540	10.0%
1	224529	10.0%
8	224183	10.0%
9	224023	10.0%
5	223931	10.0%
3	223876	10.0%
0	223850	10.0%
2	223780	10.0%
7	223383	10.0%
4	222954	10.0%

Lowercase Letter

Value	Count	Frequency (%)
e	224189	16.7%
a	224044	16.7%
d	223980	16.7%
b	223778	16.7%
f	223373	16.6%
c	223123	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2239049	62.5%
Latin	1342487	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	224540	10.0%
1	224529	10.0%
8	224183	10.0%
9	224023	10.0%
5	223931	10.0%
3	223876	10.0%
0	223850	10.0%
2	223780	10.0%
7	223383	10.0%
4	222954	10.0%

Latin

Value	Count	Frequency (%)
e	224189	16.7%
a	224044	16.7%
d	223980	16.7%
b	223778	16.7%
f	223373	16.6%
c	223123	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3581536	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	224540	6.3%
1	224529	6.3%
e	224189	6.3%
8	224183	6.3%
a	224044	6.3%
9	224023	6.3%
d	223980	6.3%
5	223931	6.3%
3	223876	6.3%
0	223850	6.3%
Other values (6)	1340391	37.4%

customer_city
Categorical

HIGH CARDINALITY

Distinct	4111
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

sao paulo	17590
rio de janeiro	7783
belo horizonte	3117
brasilia	2380
curitiba	1703
Other values (4106)	79350

Length

Max length	32
Median length	27
Mean length	10.33843803
Min length	3

Characters and Unicode

Total characters	1157109
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1060 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	barreiras
3rd row	vianopolis
4th row	sao goncalo do amarante
5th row	santo andre

Common Values

Value	Count	Frequency (%)
sao paulo	17590	15.7%
rio de janeiro	7783	7.0%
belo horizonte	3117	2.8%
brasilia	2380	2.1%
curitiba	1703	1.5%
campinas	1633	1.5%
porto alegre	1601	1.4%
salvador	1415	1.3%
guarulhos	1313	1.2%
sao bernardo do campo	1047	0.9%
Other values (4101)	72341	64.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	23726	12.1%
paulo	17670	9.0%
de	10904	5.6%
rio	9376	4.8%
janeiro	7783	4.0%
do	4835	2.5%
belo	3186	1.6%
horizonte	3145	1.6%
brasilia	2390	1.2%
porto	1910	1.0%
Other values (3279)	111242	56.7%

Most occurring characters

Value	Count	Frequency (%)
a	190734	16.5%
o	142753	12.3%
i	88671	7.7%
r	86013	7.4%
	84244	7.3%
e	75242	6.5%
s	70677	6.1%
n	51406	4.4%
u	50594	4.4%
l	50440	4.4%
Other values (21)	266335	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1072352	92.7%
Space Separator	84244	7.3%
Dash Punctuation	260	< 0.1%
Other Punctuation	251	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	190734	17.8%
o	142753	13.3%
i	88671	8.3%
r	86013	8.0%
e	75242	7.0%
s	70677	6.6%
n	51406	4.8%
u	50594	4.7%
l	50440	4.7%
p	41966	3.9%
Other values (16)	223856	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Space Separator

Value	Count	Frequency (%)
	84244	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	260	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	251	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1072352	92.7%
Common	84757	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	190734	17.8%
o	142753	13.3%
i	88671	8.3%
r	86013	8.0%
e	75242	7.0%
s	70677	6.6%
n	51406	4.8%
u	50594	4.7%
l	50440	4.7%
p	41966	3.9%
Other values (16)	223856	20.9%

Common

Value	Count	Frequency (%)
	84244	99.4%
-	260	0.3%
'	251	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1157109	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	190734	16.5%
o	142753	12.3%
i	88671	7.7%
r	86013	7.4%
	84244	7.3%
e	75242	6.5%
s	70677	6.1%
n	51406	4.4%
u	50594	4.4%
l	50440	4.4%
Other values (21)	266335	23.0%

customer_state
Categorical

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

SP	46972
RJ	14509
MG	13068
RS	6211
PR	5685
Other values (22)	25478

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	223846
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	BA
3rd row	GO
4th row	RN
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	46972	42.0%
RJ	14509	13.0%
MG	13068	11.7%
RS	6211	5.5%
PR	5685	5.1%
SC	4161	3.7%
BA	3811	3.4%
DF	2394	2.1%
GO	2329	2.1%
ES	2250	2.0%
Other values (17)	10533	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	46972	42.0%
rj	14509	13.0%
mg	13068	11.7%
rs	6211	5.5%
pr	5685	5.1%
sc	4161	3.7%
ba	3811	3.4%
df	2394	2.1%
go	2329	2.1%
es	2250	2.0%
Other values (17)	10533	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	60805	27.2%
P	56759	25.4%
R	27314	12.2%
M	15925	7.1%
G	15397	6.9%
J	14509	6.5%
A	6492	2.9%
E	5911	2.6%
C	5728	2.6%
B	4413	2.0%
Other values (7)	10593	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	223846	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	60805	27.2%
P	56759	25.4%
R	27314	12.2%
M	15925	7.1%
G	15397	6.9%
J	14509	6.5%
A	6492	2.9%
E	5911	2.6%
C	5728	2.6%
B	4413	2.0%
Other values (7)	10593	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	223846	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	60805	27.2%
P	56759	25.4%
R	27314	12.2%
M	15925	7.1%
G	15397	6.9%
J	14509	6.5%
A	6492	2.9%
E	5911	2.6%
C	5728	2.6%
B	4413	2.0%
Other values (7)	10593	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	223846	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	60805	27.2%
P	56759	25.4%
R	27314	12.2%
M	15925	7.1%
G	15397	6.9%
J	14509	6.5%
A	6492	2.9%
E	5911	2.6%
C	5728	2.6%
B	4413	2.0%
Other values (7)	10593	4.7%

dia_compra
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.51285259

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	874.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.667442147
Coefficient of variation (CV)	0.5587265204
Kurtosis	-1.171315268
Mean	15.51285259
Median Absolute Deviation (MAD)	8
Skewness	0.02641766669
Sum	1736245
Variance	75.12455336
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	4302	3.8%
16	4089	3.7%
15	3983	3.6%
6	3908	3.5%
18	3901	3.5%
19	3881	3.5%
5	3871	3.5%
14	3831	3.4%
4	3815	3.4%
7	3761	3.4%
Other values (21)	72581	64.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3503	3.1%
2	3655	3.3%
3	3678	3.3%
4	3815	3.4%
5	3871	3.5%
6	3908	3.5%
7	3761	3.4%
8	3727	3.3%
9	3671	3.3%
10	3533	3.2%

Value	Count	Frequency (%)
31	1925	1.7%
30	2877	2.6%
29	2917	2.6%
28	3365	3.0%
27	3570	3.2%
26	3720	3.3%
25	3706	3.3%
24	4302	3.8%
23	3462	3.1%
22	3488	3.1%

mes_compra
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.000670104

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	874.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.241051271
Coefficient of variation (CV)	0.5401148896
Kurtosis	-0.9756885162
Mean	6.000670104
Median Absolute Deviation (MAD)	2
Skewness	0.2285576007
Sum	671613
Variance	10.50441334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	12121	10.8%
7	11687	10.4%
3	11281	10.1%
8	11193	10.0%
6	10696	9.6%
4	10677	9.5%
2	9704	8.7%
1	9191	8.2%
11	8758	7.8%
12	6357	5.7%
Other values (2)	10258	9.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9191	8.2%
2	9704	8.7%
3	11281	10.1%
4	10677	9.5%
5	12121	10.8%
6	10696	9.6%
7	11687	10.4%
8	11193	10.0%
9	4873	4.4%
10	5385	4.8%

Value	Count	Frequency (%)
12	6357	5.7%
11	8758	7.8%
10	5385	4.8%
9	4873	4.4%
8	11193	10.0%
7	11687	10.4%
6	10696	9.6%
5	12121	10.8%
4	10677	9.5%
3	11281	10.1%

ano_compra
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

2018	60569
2017	51354

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	447692
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2018
3rd row	2018
4th row	2017
5th row	2018

Common Values

Value	Count	Frequency (%)
2018	60569	54.1%
2017	51354	45.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2018	60569	54.1%
2017	51354	45.9%

Most occurring characters

Value	Count	Frequency (%)
2	111923	25.0%
0	111923	25.0%
1	111923	25.0%
8	60569	13.5%
7	51354	11.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	447692	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	111923	25.0%
0	111923	25.0%
1	111923	25.0%
8	60569	13.5%
7	51354	11.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	447692	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	111923	25.0%
0	111923	25.0%
1	111923	25.0%
8	60569	13.5%
7	51354	11.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	447692	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	111923	25.0%
0	111923	25.0%
1	111923	25.0%
8	60569	13.5%
7	51354	11.5%

ano_mes
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	874.5 KiB

2017-11	8758
2018-01	8257
2018-03	8240
2018-04	7980
2018-05	7945
Other values (15)	70743

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	783461
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-10
2nd row	2018-07
3rd row	2018-08
4th row	2017-11
5th row	2018-02

Common Values

Value	Count	Frequency (%)
2017-11	8758	7.8%
2018-01	8257	7.4%
2018-03	8240	7.4%
2018-04	7980	7.1%
2018-05	7945	7.1%
2018-02	7706	6.9%
2018-07	7111	6.4%
2018-06	7085	6.3%
2017-12	6357	5.7%
2018-08	6245	5.6%
Other values (10)	36239	32.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11	8758	7.8%
2018-01	8257	7.4%
2018-03	8240	7.4%
2018-04	7980	7.1%
2018-05	7945	7.1%
2018-02	7706	6.9%
2018-07	7111	6.4%
2018-06	7085	6.3%
2017-12	6357	5.7%
2018-08	6245	5.6%
Other values (10)	36239	32.4%

Most occurring characters

Value	Count	Frequency (%)
0	208731	26.6%
1	150372	19.2%
2	127984	16.3%
-	111923	14.3%
8	71762	9.2%
7	63041	8.0%
5	12121	1.5%
3	11281	1.4%
6	10696	1.4%
4	10677	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	671538	85.7%
Dash Punctuation	111923	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	208731	31.1%
1	150372	22.4%
2	127984	19.1%
8	71762	10.7%
7	63041	9.4%
5	12121	1.8%
3	11281	1.7%
6	10696	1.6%
4	10677	1.6%
9	4873	0.7%

Dash Punctuation

Value	Count	Frequency (%)
-	111923	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	783461	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	208731	26.6%
1	150372	19.2%
2	127984	16.3%
-	111923	14.3%
8	71762	9.2%
7	63041	8.0%
5	12121	1.5%
3	11281	1.4%
6	10696	1.4%
4	10677	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	783461	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	208731	26.6%
1	150372	19.2%
2	127984	16.3%
-	111923	14.3%
8	71762	9.2%
7	63041	8.0%
5	12121	1.5%
3	11281	1.4%
6	10696	1.4%
4	10677	1.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	customer_unique_id	customer_city	customer_state	dia_compra	mes_compra	ano_compra	ano_mes
0	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02	2017-10-02	2017-10-04	2017-10-10	2017-10-18	1.0	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06	29.99	8.72	utilidades_domesticas	7c396fd4830fd04220f754e42b4e5bff	sao paulo	SP	2	10	2017	2017-10
1	53cdb2fc8bc7dce0b6741e2150273451	b0830fb4747a6c6d20dea0b8c802d7ef	delivered	2018-07-24	2018-07-26	2018-07-26	2018-08-07	2018-08-13	1.0	595fac2a385ac33a80bd5114aec74eb8	289cdb325fb7e7f891c38608bf9e0962	2018-07-30	118.70	22.76	perfumaria	af07308b275d755c9edb36a90c618231	barreiras	BA	24	7	2018	2018-07
2	47770eb9100c2d0c44946d9cf07ec65d	41ce2a54c0b03bf3443c3d931a367089	delivered	2018-08-08	2018-08-08	2018-08-08	2018-08-17	2018-09-04	1.0	aa4383b373c6aca5d8797843e5594415	4869f7a5dfa277a7dca6462dcf3b52b2	2018-08-13	159.90	19.22	automotivo	3a653a41f6f9fc3d2a113cf8398680e8	vianopolis	GO	8	8	2018	2018-08
3	949d5b44dbf5de918fe9c16f97b45f8a	f88197465ea7920adcdbec7375364d82	delivered	2017-11-18	2017-11-18	2017-11-22	2017-12-02	2017-12-15	1.0	d0b61bfb1de832b15ba9d266ca96e5b0	66922902710d126a0e7d26b0e3805106	2017-11-23	45.00	27.20	pet_shop	7c142cf63193a1473d2e66489a9ae977	sao goncalo do amarante	RN	18	11	2017	2017-11
4	ad21c59c0840e6cb83a9ceb5573f8159	8ab97904e6daea8866dbdbc4fb7aad2c	delivered	2018-02-13	2018-02-13	2018-02-14	2018-02-16	2018-02-26	1.0	65266b2da20d04dbe00c5c2d3bb7859e	2c9e548be18521d1c43cde1c582c6de8	2018-02-19	19.90	8.72	papelaria	72632f0f9dd73dfee390c9b22eb56dd6	santo andre	SP	13	2	2018	2018-02
5	a4591c265e18cb1dcee52889e2d8acc3	503740e9ca751ccdda7ba28e9ab8f608	delivered	2017-07-09	2017-07-09	2017-07-11	2017-07-26	2017-08-01	1.0	060cb19345d90064d1015407193c233d	8581055ce74af1daba164fdbd55a40de	2017-07-13	147.90	27.36	automotivo	80bb27c7c16e8f973207a5086ab329e2	congonhinhas	PR	9	7	2017	2017-07
6	136cce7faa42fdb2cefd53fdc79a6098	ed0271e0b7da060a393796590e7b737a	invoiced	2017-04-11	2017-04-13	NaT	NaT	2017-05-09	1.0	a1804276d9941ac0733cfd409f5206eb	dc8798cbf453b7e0f98745e396cc5616	2017-04-19	49.90	16.05	NaN	36edbb3fb164b1f16485364b6fb04c73	santa rosa	RS	11	4	2017	2017-04
7	6514b8ad8028c9f2cc2374ded245783f	9bdf08b4b3b52b5526ff42d37d47f222	delivered	2017-05-16	2017-05-16	2017-05-22	2017-05-26	2017-06-07	1.0	4520766ec412348b8d4caa5e8a18c464	16090f2ca825584b5a147ab24aa30c86	2017-05-22	59.99	15.17	automotivo	932afa1e708222e5821dac9cd5db4cae	nilopolis	RJ	16	5	2017	2017-05
8	76c6e866289321a7c93b82b54852dc33	f54a9f0e6b351c431402b8461ea51999	delivered	2017-01-23	2017-01-25	2017-01-26	2017-02-02	2017-03-06	1.0	ac1789e492dcd698c5c10b97a671243a	63b9ae557efed31d1f7687917d248a8d	2017-01-27	19.90	16.05	moveis_decoracao	39382392765b6dc74812866ee5ee92a7	faxinalzinho	RS	23	1	2017	2017-01
9	e69bfb5eb88e0ed6a785585b27e16dbf	31ad1d1b63eb9962463f764d4e6e0c9d	delivered	2017-07-29	2017-07-29	2017-08-10	2017-08-16	2017-08-23	1.0	9a78fb9862b10749a117f7fc3c31f051	7c67e1448b00f6e969d365cea6b010ab	2017-08-11	149.99	19.77	moveis_escritorio	299905e3934e9e181bfb2e164dd4b4f8	sorocaba	SP	29	7	2017	2017-07

Last rows

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	customer_unique_id	customer_city	customer_state	dia_compra	mes_compra	ano_compra	ano_mes
111913	9115830be804184b91f5c00f6f49f92d	da2124f134f5dfbce9d06f29bdb6c308	delivered	2017-10-04	2017-10-04	2017-10-05	2017-10-20	2017-11-07	1.0	c982dbea53b864f4d27c1d36f14b6053	1caf283236cd69af44cbc09a0a1e7d32	2017-10-10	42.11	0.80	brinquedos	c716cf2b5b86fb24257cffe9e7969df8	cuiaba	MT	4	10	2017	2017-10
111914	9115830be804184b91f5c00f6f49f92d	da2124f134f5dfbce9d06f29bdb6c308	delivered	2017-10-04	2017-10-04	2017-10-05	2017-10-20	2017-11-07	2.0	49d2e2460386273b195e7e59b43587c3	1caf283236cd69af44cbc09a0a1e7d32	2017-10-10	26.90	36.98	brinquedos	c716cf2b5b86fb24257cffe9e7969df8	cuiaba	MT	4	10	2017	2017-10
111915	aa04ef5214580b06b10e2a378300db44	f01a6bfcc730456317e4081fe0c9940e	delivered	2017-01-27	2017-01-27	2017-01-30	2017-02-07	2017-03-17	1.0	9fc063fd34fed29ccc57b7f8e8d03388	ccc4bbb5f32a6ab2b7066a4130f114e3	2017-02-03	370.00	19.43	beleza_saude	e03dbdf5e56c96b106d8115ac336f47f	divinopolis	MG	27	1	2017	2017-01
111916	880675dff2150932f1601e1c07eadeeb	47cd45a6ac7b9fb16537df2ccffeb5ac	delivered	2017-02-23	2017-02-23	2017-03-01	2017-03-06	2017-03-22	1.0	ea73128566d1b082e5101ce46f8107c7	391fc6631aebcf3004804e51b40bcf1e	2017-02-27	139.90	16.09	moveis_decoracao	831ce3f1bacbd424fc4e38fbd4d66d29	sao paulo	SP	23	2	2017	2017-02
111917	9c5dedf39a927c1b2549525ed64a053c	39bd1228ee8140590ac3aca26f2dfe00	delivered	2017-03-09	2017-03-09	2017-03-10	2017-03-17	2017-03-28	1.0	ac35486adb7b02598c182c2ff2e05254	e24fc9fcd865784fb25705606fe3dfe7	2017-03-15	72.00	13.08	beleza_saude	6359f309b166b0196dbf7ad2ac62bb5a	sao jose dos campos	SP	9	3	2017	2017-03
111918	63943bddc261676b46f01ca7ac2f7bd8	1fca14ff2861355f6e5f14306ff977a7	delivered	2018-02-06	2018-02-06	2018-02-07	2018-02-28	2018-03-02	1.0	f1d4ce8c6dd66c47bbaa8c6781c2a923	1f9ab4708f3056ede07124aad39a2554	2018-02-12	174.90	20.10	bebes	da62f9e57a76d978d02ab5362c509660	praia grande	SP	6	2	2018	2018-02
111919	83c1379a015df1e13d02aae0204711ab	1aa71eb042121263aafbe80c1b562c9c	delivered	2017-08-27	2017-08-27	2017-08-28	2017-09-21	2017-09-27	1.0	b80910977a37536adeddd63663f916ad	d50d79cb34e38265a8649c383dcffd48	2017-09-05	205.99	65.02	eletrodomesticos_2	737520a9aad80b3fbbdad19b66b37b30	nova vicosa	BA	27	8	2017	2017-08
111920	11c177c8e97725db2631073c19f07b62	b331b74b18dc79bcdf6532d51e1637c1	delivered	2018-01-08	2018-01-08	2018-01-12	2018-01-25	2018-02-15	1.0	d1c427060a0f73f6b889a5c7c61f2ac4	a1043bafd471dff536d0c462352beb48	2018-01-12	179.99	40.59	informatica_acessorios	5097a5312c8b157bb7be58ae360ef43c	japuiba	RJ	8	1	2018	2018-01
111921	11c177c8e97725db2631073c19f07b62	b331b74b18dc79bcdf6532d51e1637c1	delivered	2018-01-08	2018-01-08	2018-01-12	2018-01-25	2018-02-15	2.0	d1c427060a0f73f6b889a5c7c61f2ac4	a1043bafd471dff536d0c462352beb48	2018-01-12	179.99	40.59	informatica_acessorios	5097a5312c8b157bb7be58ae360ef43c	japuiba	RJ	8	1	2018	2018-01
111922	66dea50a8b16d9b4dee7af250b4be1a5	edb027a75a1449115f6b43211ae02a24	delivered	2018-03-08	2018-03-09	2018-03-09	2018-03-16	2018-04-03	1.0	006619bbed68b000c8ba3f8725d5409e	ececbfcff9804a2d6b40f589df8eef2b	2018-03-15	68.50	18.36	beleza_saude	60350aa974b26ff12caad89e55993bd6	lapa	PR	8	3	2018	2018-03

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Decimal Number

Most occurring scripts